package com.hna.eking.AirGisPlt.MybatisImp;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import com.hna.eking.AirGisPlt.Mapper.WetherStationMapper;
public interface WetherStationInfo {
	@Select("select tb1.*, tb2.dist from (select *, ST_Distance( ST_GeomFromText(#{PointPos}, 4326), geom) dist from station_info ) tb1,(select  min(dist)  dist from (select areacode, ST_Distance( ST_GeomFromText(#{PointPos}, 4326), geom) dist from station_info) tb where dist <> 0 ) tb2 where tb1.dist = tb2.dist")
	//@Select("select * from station_info where geom = ST_GeomFromText(#{PointPos}, 4326)")
	public List<WetherStationMapper> getByStationCode(String PointPos);
}
